*===============================================================================
*=== FILE 5 --- CLEAN COUNTY LIST
*===============================================================================
cap cd ""

import delimited "data\actual\countyList.txt", delimiter("||", collapse) clear

rename regionid regionid_
rename regionname regionname_
rename statename statename_

rename regionname_ countyregionid
rename statename_ regionname
rename v4 statename

drop regionid_
drop regionname

label variable countyregionid "CountyRegionID"
label variable statename "StateName"

save "replication output\regionid_statename", replace
